package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_merchant_channel", simpleName = "", engine = MysqlDriver.InnoDB, comment = "商户渠道")
public class _DDL_CMerchantChannel {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, autoIncrement = true, comment = "id")
    private Long id;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "ch_id", type = SqlType.VARCHAR, size = 32, comment = "商户渠道id")
    private String chId;

    @_DDL_Column(name = "ch_type", type = SqlType.TINYINT_UNSIGNED, nullable = false, comment = "类型 1:平安 ")
    private Integer chType;

    @_DDL_Column(name = "ch_state", type = SqlType.VARCHAR, size = 20, comment = "外部审核状态")
    private String chState;

    @_DDL_Column(name = "err_msg", type = SqlType.VARCHAR, size = 200, comment = "错误原因")
    private String errMsg;

    @_DDL_Column(name = "reason", type = SqlType.VARCHAR, size = 200, comment = "审核失败愿意")
    private String reason;

    @_DDL_Column(name = "state", type = SqlType.VARCHAR, size = 10, comment = "内部状态")
    private String state;

    @_DDL_Column(name = "extra", type = SqlType.BLOB, comment = "商户开户的信息(加密)")
    private byte[] extra;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "up_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP_ON_UPDATE, comment = "修改时间")
    private java.sql.Timestamp upTime;

}
